# encoding：utf-8
# @File   : read_file.py
# @Author : 乖孩子
# @Date   : 2025-05-12 13-36-15
from openpyxl import load_workbook


def read_addSubSystem_xlsx_data(file_path):
    workbook = load_workbook(file_path)
    sheet = workbook.active
    testdata = []
    for row in sheet.iter_rows(min_row=2, values_only=True):                # 从第二行开始，跳过表头
        IsUseMultiAlarm, OEM, OrderID, Remark, SubSystemName, SubSystemTypeID = row
        testdata.append((IsUseMultiAlarm, OEM, OrderID, Remark, SubSystemName, SubSystemTypeID))

    return testdata

